package monitora.bean;

import java.io.Serializable;
import java.sql.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

import org.hibernate.annotations.NamedNativeQueries;
import org.hibernate.annotations.NamedNativeQuery;

@Entity
@Table(name="TB_FORMULARIO2", schema="MONITORA")

@NamedNativeQueries({
	@NamedNativeQuery(
			name="formulario2", query="SELECT * FROM MONITORA.TB_FORMULARIO2", resultClass=Formulario2Bean.class),
	@NamedNativeQuery(
			name="formulario2_codigo", query="SELECT * FROM MONITORA.TB_FORMULARIO2 WHERE CD_PREFEITURA = :CODIGO", resultClass=Formulario2Bean.class),
	@NamedNativeQuery(
			name="formulario2_sem_arquivo", query="SELECT * FROM MONITORA.FORMULARIO2_SEM_ARQUIVO(:CODIGO)", resultClass=Formulario2Bean.class)
})
public class Formulario2Bean implements Serializable {

	@Id
	@SequenceGenerator(name="FORMULARIO2", sequenceName="MONITORA.SQ_FORMULARIO2")
	@GeneratedValue(generator="FORMULARIO2", strategy=GenerationType.AUTO)
	@Column(name="CD_FORMULARIO2")
	private int codigo;
	
	@Column(name="CD_PREFEITURA")
	private int codigoPrefeitura;
	
	@Column(name="Q1")
	private String q1;
	
	@Column(name="Q1N")
	private String q1n;
	
	@Column(name="Q2")
	private String q2;
	
	@Column(name="QA2N")
	private String qa2n;
	
	@Column(name="Q2A")
	private byte[] q2a;
	
	@Column(name="Q3")
	private String q3;
	
	@Column(name="Q3N")
	private String q3n;
	
	@Column(name="Q4")
	private String q4;
	
	@Column(name="Q4N")
	private String q4n;
	
	@Column(name="Q51")
	private String q51;
	
	@Column(name="Q52")
	private String q52;
	
	@Column(name="Q53")
	private String q53;
	
	@Column(name="Q54")
	private String q54;
	
	@Column(name="Q6")
	private String q6;
	
	@Column(name="Q6S")
	private String q6s;
	
	@Column(name="Q6N")
	private String q6n;
	
	@Column(name="Q6T")
	private String q6t;
	
	@Column(name="Q7")
	private String q7;
	
	@Column(name="Q7N")
	private String q7n;
	
	@Column(name="Q8")
	private String q8;
	
	@Column(name="Q8N")
	private String q8n;
	
	@Column(name="Q9")
	private String q9;
	
	@Column(name="Q9N")
	private String q9n;
	
	@Column(name="Q10")
	private String q10;
	
	@Column(name="QA10N")
	private String qa10n;
	
	@Column(name="Q10A")
	private byte[] q10a;
	
	@Column(name="Q11")
	private String q11;
	
	@Column(name="QA11SN")
	private String qa11sn;
	
	@Column(name="Q11SA")
	private byte[] q11sa;
	
	@Column(name="Q11N")
	private String q11n;
	
	@Column(name="Q12")
	private String q12;
	
	@Column(name="Q12N")
	private String q12n;
	
	@Column(name="Q13")
	private String q13;
	
	@Column(name="Qa13n")
	private String qa13n;
	
	@Column(name="Q13a")
	private byte[] q13a;

	public int getCodigo() {
		return codigo;
	}

	public void setCodigo(int codigo) {
		this.codigo = codigo;
	}

	public int getCodigoPrefeitura() {
		return codigoPrefeitura;
	}

	public void setCodigoPrefeitura(int codigoPrefeitura) {
		this.codigoPrefeitura = codigoPrefeitura;
	}

	public String getQ1() {
		return q1;
	}

	public void setQ1(String q1) {
		this.q1 = q1;
	}

	public String getQ1n() {
		return q1n;
	}

	public void setQ1n(String q1n) {
		this.q1n = q1n;
	}

	public String getQ2() {
		return q2;
	}

	public void setQ2(String q2) {
		this.q2 = q2;
	}

	public String getQa2n() {
		return qa2n;
	}

	public void setQa2n(String qa2n) {
		this.qa2n = qa2n;
	}

	public byte[] getQ2a() {
		return q2a;
	}

	public void setQ2a(byte[] q2a) {
		this.q2a = q2a;
	}

	public String getQ3() {
		return q3;
	}

	public void setQ3(String q3) {
		this.q3 = q3;
	}

	public String getQ3n() {
		return q3n;
	}

	public void setQ3n(String q3n) {
		this.q3n = q3n;
	}

	public String getQ4() {
		return q4;
	}

	public void setQ4(String q4) {
		this.q4 = q4;
	}

	public String getQ4n() {
		return q4n;
	}

	public void setQ4n(String q4n) {
		this.q4n = q4n;
	}

	public String getQ51() {
		return q51;
	}

	public void setQ51(String q51) {
		this.q51 = q51;
	}

	public String getQ52() {
		return q52;
	}

	public void setQ52(String q52) {
		this.q52 = q52;
	}

	public String getQ53() {
		return q53;
	}

	public void setQ53(String q53) {
		this.q53 = q53;
	}

	public String getQ54() {
		return q54;
	}

	public void setQ54(String q54) {
		this.q54 = q54;
	}

	public String getQ6() {
		return q6;
	}

	public void setQ6(String q6) {
		this.q6 = q6;
	}

	public String getQ6s() {
		return q6s;
	}

	public void setQ6s(String q6s) {
		this.q6s = q6s;
	}

	public String getQ6n() {
		return q6n;
	}

	public void setQ6n(String q6n) {
		this.q6n = q6n;
	}

	public String getQ6t() {
		return q6t;
	}

	public void setQ6t(String q6t) {
		this.q6t = q6t;
	}

	public String getQ7() {
		return q7;
	}

	public void setQ7(String q7) {
		this.q7 = q7;
	}

	public String getQ7n() {
		return q7n;
	}

	public void setQ7n(String q7n) {
		this.q7n = q7n;
	}

	public String getQ8() {
		return q8;
	}

	public void setQ8(String q8) {
		this.q8 = q8;
	}

	public String getQ8n() {
		return q8n;
	}

	public void setQ8n(String q8n) {
		this.q8n = q8n;
	}

	public String getQ9() {
		return q9;
	}

	public void setQ9(String q9) {
		this.q9 = q9;
	}

	public String getQ9n() {
		return q9n;
	}

	public void setQ9n(String q9n) {
		this.q9n = q9n;
	}

	public String getQ10() {
		return q10;
	}

	public void setQ10(String q10) {
		this.q10 = q10;
	}

	public String getQa10n() {
		return qa10n;
	}

	public void setQa10n(String qa10n) {
		this.qa10n = qa10n;
	}

	public byte[] getQ10a() {
		return q10a;
	}

	public void setQ10a(byte[] q10a) {
		this.q10a = q10a;
	}

	public String getQ11() {
		return q11;
	}

	public void setQ11(String q11) {
		this.q11 = q11;
	}
	
	public String getQa11sn() {
		return qa11sn;
	}

	public void setQa11sn(String qa11sn) {
		this.qa11sn = qa11sn;
	}

	public byte[] getQ11sa() {
		return q11sa;
	}

	public void setQ11sa(byte[] q11sa) {
		this.q11sa = q11sa;
	}

	public String getQ11n() {
		return q11n;
	}

	public void setQ11n(String q11n) {
		this.q11n = q11n;
	}

	public String getQ12() {
		return q12;
	}

	public void setQ12(String q12) {
		this.q12 = q12;
	}

	public String getQ12n() {
		return q12n;
	}

	public void setQ12n(String q12n) {
		this.q12n = q12n;
	}

	public String getQ13() {
		return q13;
	}

	public void setQ13(String q13) {
		this.q13 = q13;
	}

	public String getQa13n() {
		return qa13n;
	}

	public void setQa13n(String qa13n) {
		this.qa13n = qa13n;
	}

	public byte[] getQ13a() {
		return q13a;
	}

	public void setQ13a(byte[] q13a) {
		this.q13a = q13a;
	}
	
}
